/*
 Navicat Premium Data Transfer

 Source Server         : docker
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : localhost:3306
 Source Schema         : ssms

 Target Server Type    : MySQL
 Target Server Version : 50724
 File Encoding         : 65001

 Date: 25/12/2018 18:08:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(30) COLLATE utf8_unicode_ci DEFAULT '111111',
  `name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` tinyint(1) DEFAULT '2',
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_user_FK` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (null, 'admin', '111111', '管理员', 1);
INSERT INTO `user` VALUES (null, '2001', '111111', '卡卡西', 3);
INSERT INTO `user` VALUES (null, '2002', '111111', '卡普', 3);
INSERT INTO `user` VALUES (null, '2003', '111111', '战国', 3);
INSERT INTO `user` VALUES (null, '2004', '111111', '青雉', 3);
INSERT INTO `user` VALUES (null, '2005', '111111', '爱德华纽盖特', 3);
INSERT INTO `user` VALUES (null, '2006', '111111', '香克斯', 3);
INSERT INTO `user` VALUES (null, '2007', '111111', '波风水门', 3);
INSERT INTO `user` VALUES (null, '2008', '111111', '纲手', 3);
INSERT INTO `user` VALUES (null, '2009', '111111', '大筒木辉夜', 3);
INSERT INTO `user` VALUES (null, '2010', '111111', '漩涡玖辛奈', 3);
INSERT INTO `user` VALUES (null, '2011', '111111', '夕日红', 3);
INSERT INTO `user` VALUES (null, '2012', '111111', '鹰眼米霍克', 3);
INSERT INTO `user` VALUES (null, '201301001', '111111', '蒙奇D路飞', 2);
INSERT INTO `user` VALUES (null, '201301002', '111111', '妮可罗宾', 2);
INSERT INTO `user` VALUES (null, '201301003', '111111', '罗罗诺亚卓洛', 2);
INSERT INTO `user` VALUES (null, '201301004', '111111', '托尼托尼乔巴', 2);
INSERT INTO `user` VALUES (null, '201301005', '111111', '娜美', 2);
INSERT INTO `user` VALUES (null, '201301006', '111111', '山治', 2);
INSERT INTO `user` VALUES (null, '201301007', '111111', '布鲁克', 2);
INSERT INTO `user` VALUES (null, '201301008', '111111', '乌索普', 2);
INSERT INTO `user` VALUES (null, '201301009', '111111', '弗兰奇', 2);
INSERT INTO `user` VALUES (null, '201301010', '111111', '娜菲鲁塔利薇薇', 2);
INSERT INTO `user` VALUES (null, '201301011', '111111', '小鱿', 2);
INSERT INTO `user` VALUES (null, '201301012', '111111', '梅里号', 2);
INSERT INTO `user` VALUES (null, '201301013', '111111', '阳光号', 2);
INSERT INTO `user` VALUES (null, '201302001', '111111', '马歇尔蒂奇', 2);
INSERT INTO `user` VALUES (null, '201302002', '111111', '范奥卡', 2);
INSERT INTO `user` VALUES (null, '201302003', '111111', '基萨斯巴加斯', 2);
INSERT INTO `user` VALUES (null, '201302004', '111111', '毒Q', 2);
INSERT INTO `user` VALUES (null, '201302005', '111111', '雨之希留', 2);
INSERT INTO `user` VALUES (null, '201302006', '111111', '卡特琳娜', 2);
INSERT INTO `user` VALUES (null, '201302007', '111111', '圣胡安恶狼', 2);
INSERT INTO `user` VALUES (null, '201302008', '111111', '巴克斯乔特', 2);
INSERT INTO `user` VALUES (null, '201302009', '111111', '阿巴罗', 2);
INSERT INTO `user` VALUES (null, '201303001', '111111', '汉库克', 2);
INSERT INTO `user` VALUES (null, '201303002', '111111', '桑达索尼娅', 2);
INSERT INTO `user` VALUES (null, '201303003', '111111', '玛丽哥鲁德', 2);
INSERT INTO `user` VALUES (null, '201303004', '111111', '玛格丽特', 2);
INSERT INTO `user` VALUES (null, '201303005', '111111', '艾弗兰德拉', 2);
INSERT INTO `user` VALUES (null, '201303006', '111111', '贝拉董娜', 2);
INSERT INTO `user` VALUES (null, '201304001', '111111', '白胡子', 2);
INSERT INTO `user` VALUES (null, '201304002', '111111', '马尔高', 2);
INSERT INTO `user` VALUES (null, '201304003', '111111', '艾斯', 2);
INSERT INTO `user` VALUES (null, '201304004', '111111', '乔兹', 2);
INSERT INTO `user` VALUES (null, '201304005', '111111', '萨奇', 2);
INSERT INTO `user` VALUES (null, '201304006', '111111', '比斯塔', 2);
INSERT INTO `user` VALUES (null, '201304007', '111111', '布拉曼克', 2);
INSERT INTO `user` VALUES (null, '201304008', '111111', '拉克约', 2);
INSERT INTO `user` VALUES (null, '201304009', '111111', '那谬尔', 2);
INSERT INTO `user` VALUES (null, '201304010', '111111', '布伦海姆', 2);
INSERT INTO `user` VALUES (null, '201304011', '111111', '库利艾尔', 2);
INSERT INTO `user` VALUES (null, '201304012', '111111', '金古多', 2);
INSERT INTO `user` VALUES (null, '201304013', '111111', '佛萨', 2);
INSERT INTO `user` VALUES (null, '201304014', '111111', '斯比多基尔', 2);
INSERT INTO `user` VALUES (null, '201401001', '111111', '日向雏田', 2);
INSERT INTO `user` VALUES (null, '201401002', '111111', '李洛克', 2);
INSERT INTO `user` VALUES (null, '201401003', '111111', '日向花火', 2);
INSERT INTO `user` VALUES (null, '201401004', '111111', '奈良鹿丸', 2);
INSERT INTO `user` VALUES (null, '201401005', '111111', '日向宁次', 2);
INSERT INTO `user` VALUES (null, '201401006', '111111', '佐井', 2);
INSERT INTO `user` VALUES (null, '201401007', '111111', '山中井野', 2);
INSERT INTO `user` VALUES (null, '201401008', '111111', '秋道丁次', 2);
INSERT INTO `user` VALUES (null, '201401009', '111111', '犬冢牙', 2);
INSERT INTO `user` VALUES (null, '201401010', '111111', '野原琳', 2);
INSERT INTO `user` VALUES (null, '201401011', '111111', '天天', 2);
INSERT INTO `user` VALUES (null, '201401012', '111111', '木叶丸', 2);
INSERT INTO `user` VALUES (null, '201401013', '111111', '赤丸', 2);
INSERT INTO `user` VALUES (null, '201401014', '111111', '漩涡鸣人', 2);
INSERT INTO `user` VALUES (null, '201401015', '111111', '佐助', 2);
INSERT INTO `user` VALUES (null, '201401016', '111111', '春野樱', 2);
INSERT INTO `user` VALUES (null, '201401017', '111111', '油女志乃', 2);
INSERT INTO `user` VALUES (null, '201402001', '111111', '宇智波带土', 2);
INSERT INTO `user` VALUES (null, '201402002', '111111', '长门', 2);
INSERT INTO `user` VALUES (null, '201402003', '111111', '绝', 2);
INSERT INTO `user` VALUES (null, '201402004', '111111', '角都', 2);
INSERT INTO `user` VALUES (null, '201402005', '111111', '迪达拉', 2);
INSERT INTO `user` VALUES (null, '201402006', '111111', '小南', 2);
INSERT INTO `user` VALUES (null, '201402007', '111111', '大蛇丸', 2);
INSERT INTO `user` VALUES (null, '201402008', '111111', '飞段', 2);
INSERT INTO `user` VALUES (null, '201402009', '111111', '蝎', 2);
INSERT INTO `user` VALUES (null, '201402010', '111111', '弥彦', 2);
INSERT INTO `user` VALUES (null, '201402011', '111111', '千柿鬼鲛', 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
